package com.hk.aefz.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hk.aefz.po.Special;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 个人分类专栏 Mapper 接口
 * </p>
 *
 * @author 阿尔法哲
 * @since 2020-07-25
 */
public interface SpecialMapper extends BaseMapper<Special> {

    @Select("select s.sid as sid,s.sname as sname,e.bid as bid from special s join essay_classify e on s.sid = e.sid and e.eid = #{eid}; ")
    Special selectByEid(@Param("eid") Integer eid);
}
